alter table problem add IS_SOLVED bit default 0
go
alter table problem add IS_SANWEI bit default 0
go
alter table deleted_problem add IS_SOLVED bit default 0
go
alter table deleted_problem add IS_SANWEI bit default 0
go
update problem set IS_SOLVED=0
go
update problem set IS_SANWEI=0
go
update deleted_problem set IS_SOLVED=0
go
update deleted_problem set IS_SANWEI=0
go
update problem set IS_SOLVED=1 where PROBLEM_CONTENT='经观察正常。'
